--------------JIANG PACKAGE BODY--------------
CREATE OR REPLACE PACKAGE BODY Jiang AS
    FUNCTION getID RETURN number IS
        id_to_return number;
    BEGIN
        select 
        to_number(
            --to_char(systimestamp, 'yyyy') ||
            to_char(systimestamp, 'MM') ||
            to_char(systimestamp, 'dd') ||
            to_char(systimestamp, 'HH24') ||
            to_char(systimestamp, 'MI') ||
            to_char(systimestamp, 'SS') ||
            to_char(jiang_id_sequence.nextval)
        )
        into id_to_return
        from dual;
        RETURN id_to_return;
    END;
END;
/
--commit;